﻿create proc loadmenucon 
@MaNhom as int
as
select b.MenuID,b.TenMenu,b.TenModule,b.TenThuMuc,b.TenForm
from DanhMuc_Menu b Where MenuID not in (select MenuID from QuanTri_PhanNhomMenu Where MaNhomMenuND=@MaNhom)